Skip Headers

Oracle® Data Provider for .NET Developer's Guide 10g Release 2 (10.2) Part Number B14307-01 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# OracleTimeStampLTZ Structure

The `OracleTimeStampLTZ` structure represents the Oracle `TIMESTAMP` `WITH` `LOCAL` `TIME` `ZONE` datatype to be stored in or retrieved from a database. Each `OracleTimeStampLTZ` stores the following information: year, month, day, hour, minute, second, and nanosecond.

Class Inheritance

`Object`

`ValueType`

`OracleTimeStampLTZ`

Declaration

    // C#
    public struct OracleTimeStampLTZ : IComparable

Thread Safety

All public static methods are thread-safe, although instance methods do not guarantee thread safety.

Example

    // C#

    using System;
    using Oracle.DataAccess.Types;
    using Oracle.DataAccess.Client;

    class OracleTimeStampLTZSample
    {
      static void Main()
      {
        // Illustrates usage of OracleTimeStampLTZ
        // Display Local Time Zone Name
        Console.WriteLine("Local Time Zone Name = " +
          OracleTimeStampLTZ.GetLocalTimeZoneName());
        OracleTimeStampLTZ tsLocal1 = OracleTimeStampLTZ.GetSysDate();
        OracleTimeStampLTZ tsLocal2 = DateTime.Now;

        // Calculate the difference between tsLocal1 and tsLocal2
        OracleIntervalDS idsDiff = tsLocal2.GetDaysBetween(tsLocal1);

        // Calculate the difference using AddNanoseconds()
        int nanoDiff = 0;
        while (tsLocal2 > tsLocal1)
        {
          nanoDiff += 10;
          tsLocal1 = tsLocal1.AddNanoseconds(10);
        }
        Console.WriteLine("idsDiff.Nanoseconds = " + idsDiff.Nanoseconds);
        Console.WriteLine("nanoDiff = " + nanoDiff);
      }
    }

Requirements

Namespace: `Oracle.DataAccess.Types`

Assembly: `Oracle.DataAccess.dll`

See Also: "Oracle.DataAccess.Types Namespace" OracleTimeStampLTZ Members OracleTimeStampLTZ Constructors OracleTimeStampLTZ Static Fields OracleTimeStampLTZ Static Methods OracleTimeStampLTZ Static Operators OracleTimeStampLTZ Static Type Conversions OracleTimeStampLTZ Properties OracleTimeStampLTZ Methods

## OracleTimeStampLTZ Members

`OracleTimeStampLTZ` members are listed in the following tables:

OracleTimeStampLTZ Constructors

`OracleTimeStampLTZ` constructors are listed in Table 11-100

Table 11-100 OracleTimeStampLTZConstructors

Constructor | Description
--- | ---
OracleTimeStampLTZ Constructors | Instantiates a new instance of `OracleTimeStampLTZ` structure (Overloaded)

OracleTimeStampLTZ Static Fields

The `OracleTimeStampLTZ` static fields are listed in Table 11-101.

Table 11-101 OracleTimeStampLTZ Static Fields

Field | Description
--- | ---
MaxValue | Represents the maximum valid date for an `OracleTimeStampLTZ` structure, which is December 31, 9999 23:59:59.999999999
MinValue | Represents the minimum valid date for an `OracleTimeStampLTZ` structure, which is January 1, -4712 0:0:0
Null | Represents a null value that can be assigned to an instance of the `OracleTimeStampLTZ` structure

OracleTimeStampLTZ Static Methods

The `OracleTimeStampLTZ` static methods are listed in Table 11-102.

Table 11-102 OracleTimeStampLTZ Static Methods

Methods | Description
--- | ---
Equals | Determines if two `OracleTimeStampLTZ` values are equal (Overloaded)
GetLocalTimeZoneName | Gets the client's local time zone name
GetLocalTimeZoneOffset | Gets the client's local time zone offset relative to UTC
GetSysDate | Gets an `OracleTimeStampLTZ` structure that represents the current date and time
GreaterThan | Determines if the first of two `OracleTimeStampLTZ` values is greater than the second
GreaterThanOrEqual | Determines if the first of two `OracleTimeStampLTZ` values is greater than or equal to the second
LessThan | Determines if the first of two `OracleTimeStampLTZ` values is less than the second
LessThanOrEqual | Determines if the first of two `OracleTimeStampLTZ` values is less than or equal to the second
NotEquals | Determines if two `OracleTimeStampLTZ` values are not equal
Parse | Gets an `OracleTimeStampLTZ` structure and sets its value for date and time using the supplied string
SetPrecision | Returns a new instance of an `OracleTimeStampLTZ` with the specified fractional second precision

OracleTimeStampLTZ Static Operators

The `OracleTimeStampLTZ` static operators are listed in Table 11-103.

Table 11-103 OracleTimeStampLTZ Static Operators

Operator | Description
--- | ---
operator+ | Adds the supplied instance value to the supplied `OracleTimeStampLTZ` and returns a new `OracleTimeStampLTZ` structure (Overloaded)
operator == | Determines if two `OracleTimeStampLTZ` values are equal
operator > | Determines if the first of two `OracleTimeStampLTZ` values is greater than the second
operator >= | Determines if the first of two `OracleTimeStampLTZ` values is greater than or equal to the second
operator != | Determines if two `OracleTimeStampLTZ` values are not equal
operator < | Determines if the first of two `OracleTimeStampLTZ` values is less than the second
operator <= | Determines if the first of two `OracleTimeStampLTZ` values is less than or equal to the second
operator - | Subtracts the supplied instance value from the supplied `OracleTimeStampLTZ` and returns a new `OracleTimeStampLTZ` structure (Overloaded)

OracleTimeStampLTZ Static Type Conversions

The `OracleTimeStampLTZ` static type conversions are listed in Table 11-104.

Table 11-104 OracleTimeStampLTZ Static Type Conversions

Operator | Description
--- | ---
explicit operator OracleTimeStampLTZ | Converts an instance value to an `OracleTimeStampLTZ` structure (Overloaded)
implicit operator OracleTimeStampLTZ | Converts an instance value to an `OracleTimeStampLTZ` structure (Overloaded)
explicit operator DateTime | Converts an `OracleTimeStampLTZ` value to a `DateTime` structure

OracleTimeStampLTZ Properties

The `OracleTimeStampLTZ` properties are listed in Table 11-105.

Table 11-105 OracleTimeStampLTZ Properties

Properties | Description
--- | ---
BinData | Returns an array of bytes that represents an `Oracle TIMESTAMP` `WITH` `LOCAL` `TIME` `ZONE` in Oracle internal format
Day | Specifies the `day` component of an `OracleTimeStampLTZ`
IsNull | Indicates whether or not the `OracleTimeStampLTZ` instance has a null value
Hour | Specifies the hour component of an `OracleTimeStampLTZ`
Millisecond | Specifies the millisecond component of an `OracleTimeStampLTZ`
Minute | Specifies the minute component of an `OracleTimeStampLTZ`
Month | Specifies the month component of an `OracleTimeStampLTZ`
Nanosecond | Specifies the nanosecond component of an `OracleTimeStampLTZ`
Second | Specifies the second component of an `OracleTimeStampLTZ`
Value | Specifies the date and time that is stored in the `OracleTimeStampLTZ` structure
Year | Specifies the year component of an `OracleTimeStampLTZ`

OracleTimeStampLTZ Methods

The `OracleTimeStampLTZ` methods are listed in Table 11-106.

Table 11-106 OracleTimeStampLTZ Methods

Methods | Description
--- | ---
AddDays | Adds the supplied number of days to the current instance
AddHours | Adds the supplied number of hours to the current instance
AddMilliseconds | Adds the supplied number of milliseconds to the current instance
AddMinutes | Adds the supplied number of minutes to the current instance
AddMonths | Adds the supplied number of months to the current instance
AddNanoseconds | Adds the supplied number of nanoseconds to the current instance
AddSeconds | Adds the supplied number of seconds to the current instance
AddYears | Adds the supplied number of years to the current instance
CompareTo | Compares the current `OracleTimeStampLTZ` instance to an object and returns an integer that represents their relative values
Equals | Determines whether or not an object has the same date and time as the current `OracleTimeStampLTZ` instance (Overloaded)
GetHashCode | Returns a hash code for the `OracleTimeStampLTZ` instance
GetDaysBetween | Subtracts an `OracleTimeStampLTZ` from the current instance and returns an `OracleIntervalDS` that represents the difference
GetYearsBetween | Subtracts an `OracleTimeStampLTZ` from the current instance and returns an `OracleIntervalYM` that represents the difference
GetType | Inherited from `Object`
ToOracleDate | Converts the current `OracleTimeStampLTZ` structure to an `OracleDate` structure
ToOracleTimeStamp | Converts the current `OracleTimeStampLTZ` structure to an `OracleTimeStamp` structure
ToOracleTimeStampTZ | Converts the current `OracleTimeStampLTZ` structure to an `OracleTimeStampTZ` structure
ToString | Converts the current `OracleTimeStampLTZ` structure to a string
ToUniversalTime | Converts the current local time to Coordinated Universal Time (UTC)

See Also: "Oracle.DataAccess.Types Namespace" OracleTimeStampLTZ Structure

## OracleTimeStampLTZ Constructors

The `OracleTimeStampLTZ` constructors create new instances of the `OracleTimeStampLTZ` structure.

Overload List:

- OracleTimeStampLTZ(DateTime)

  This constructor creates a new instance of the `OracleTimeStampLTZ` structure and sets its value for date and time using the supplied `DateTime` value.

- OracleTimeStampLTZ(string)

  This constructor creates a new instance of the `OracleTimeStampLTZ` structure and sets its value for date and time using the supplied string.

- OracleTimeStampLTZ(int, int, int)

  This constructor creates a new instance of the `OracleTimeStampLTZ` structure and sets its value for date using year, month, and day.

- OracleTimeStampLTZ(int, int, int, int, int, int)

  This constructor creates a new instance of the `OracleTimeStampLTZ` structure and sets its value for date and time using year, month, day, hour, minute, and second.

- OracleTimeStampLTZ(int, int, int, int, int, int, double)

  This constructor creates a new instance of the `OracleTimeStampLTZ` structure and sets its value for date and time using year, month, day, hour, minute, second, and millisecond.

- OracleTimeStampLTZ(int, int, int, int, int, int, int)

  This constructor creates a new instance of the `OracleTimeStampLTZ` structure and sets its value for date and time using year, month, day, hour, minute, second, and nanosecond.

- OracleTimeStampLTZ(byte [ ])

  This constructor creates a new instance of the `OracleTimeStampLTZ` structure and sets its value to the provided byte array, which is in the internal Oracle `TIMESTAMP` `WITH` `LOCAL` `TIME` `ZONE` format.

See Also: "Oracle.DataAccess.Types Namespace" OracleTimeStampLTZ Structure OracleTimeStampLTZ Members

### OracleTimeStampLTZ(DateTime)

This constructor creates a new instance of the `OracleTimeStampLTZ` structure and sets its value for date and time using the supplied `DateTime` value.

Declaration

    // C#
    public OracleTimeStampLTZ (DateTime dt);

Parameters

- `dt`

  The supplied `DateTime` value.

Exceptions

`ArgumentException` - The `dt` parameter cannot be used to construct a valid `OracleTimeStampLTZ`.

See Also: "Oracle.DataAccess.Types Namespace" OracleTimeStampLTZ Structure OracleTimeStampLTZ Members

### OracleTimeStampLTZ(string)

This constructor creates a new instance of the `OracleTimeStampLTZ` structure and sets its value for date and time using the supplied string.

Declaration

    // C#
    public OracleTimeStampLTZ(string tsStr);

Parameters

- `tsStr`

  A string that represents an Oracle `TIMESTAMP` `WITH` `LOCAL` `TIME` `ZONE`.

Exceptions

`ArgumentException` - The `tsStr` is an invalid string representation of an Oracle `TIMESTAMP` `WITH` `LOCAL` `TIME` `ZONE` or the supplied `tsStr` is not in the timestamp format specified by the `OracleGlobalization`.`TimeStampFormat` property of the thread, which represents the Oracle `NLS_TIMESTAMP_FORMAT` parameter.

`ArgumentNullException` - The `tsStr` value is null.

Remarks

The names and abbreviations used for months and days are in the language specified by the `DateLanguage` and `Calendar` properties of the thread's `OracleGlobalization` object. If any of the thread's globalization properties are set to null or an empty string, the client computer's settings are used.

Example

    // C#

    using System;
    using Oracle.DataAccess.Client;
    using Oracle.DataAccess.Types;

    class OracleTimeStampLTZSample
    {
      static void Main()
      {
        // Set the nls_timestamp_format for the OracleTimeStampLTZ(string)
        // constructor
        OracleGlobalization info = OracleGlobalization.GetClientInfo();
        info.TimeStampFormat = "DD-MON-YYYY HH:MI:SS.FF AM";
        OracleGlobalization.SetThreadInfo(info);

        // construct OracleTimeStampLTZ from a string using the format
        // specified.
        OracleTimeStampLTZ ts =
          new OracleTimeStampLTZ("11-NOV-1999 11:02:33.444 AM");

        // Set the nls_timestamp_format for the ToString() method
        info.TimeStampFormat = "YYYY-MON-DD HH:MI:SS.FF AM";
        OracleGlobalization.SetThreadInfo(info);

        // Prints "1999-NOV-11 11:02:33.444000000 AM"
        Console.WriteLine(ts.ToString());
      }
    }

See Also: "Oracle.DataAccess.Types Namespace" OracleTimeStampLTZ Structure OracleTimeStampLTZ Members "OracleGlobalization Class" "Globalization Support" Oracle Database SQL Reference for further information on date format elements

### OracleTimeStampLTZ(int, int, int)

This constructor creates a new instance of the `OracleTimeStampLTZ` structure and sets its value for date using year, month, and day.

Declaration

    // C#
    public OracleTimeStampLTZ(int year, int month, int day);

Parameters

- `year`

  The year provided. Range of `year` is (-4712 to 9999).

- `month`

  The month provided. Range of `month` is (1 to 12).

- `day`

  The day provided. Range of `day` is (1 to 31).

Exceptions

`ArgumentOutOfRangeException` - The argument value for one or more of the parameters is out of the specified range.

`ArgumentException` - The argument values of the parameters cannot be used to construct a valid `OracleTimeStampLTZ` (that is, the day is out of range for the month).

See Also: "Oracle.DataAccess.Types Namespace" OracleTimeStampLTZ Structure OracleTimeStampLTZ Members

### OracleTimeStampLTZ(int, int, int, int, int, int)

This constructor creates a new instance of the `OracleTimeStampLTZ` structure and sets its value for date and time using year, month, day, hour, minute, and second.

Declaration

    // C#
    public OracleTimeStampLTZ (int year, int month, int day, int hour,
      int minute, int second);

Parameters

- `year`

  The year provided. Range of `year` is (-4712 to 9999).

- `month`

  The month provided. Range of `month` is (1 to 12).

- `day`

  The day provided. Range of `day` is (1 to 31).

- `hour`

  The hour provided. Range of `hour` is (0 to 23).

- `minute`

  The minute provided. Range of `minute` is (0 to 59).

- `second`

  The second provided. Range of `second` is (0 to 59).

Exceptions

`ArgumentOutOfRangeException` - The argument value for one or more of the parameters is out of the specified range.

`ArgumentException` - The argument values of the parameters cannot be used to construct a valid `OracleTimeStampLTZ` (that is, the day is out of range for the month).

See Also: "Oracle.DataAccess.Types Namespace" OracleTimeStampLTZ Structure OracleTimeStampLTZ Members

### OracleTimeStampLTZ(int, int, int, int, int, int, double)

This constructor creates a new instance of the `OracleTimeStampLTZ` structure and sets its value for date and time using year, month, day, hour, minute, second, and millisecond.

Declaration

    // C#
    public OracleTimeStampLTZ(int year, int month, int day, int hour, int minute, int second, double millisecond);

Parameters

- `year`

  The year provided. Range of `year` is (-4712 to 9999).

- `month`

  The month provided. Range of `month` is (1 to 12).

- `day`

  The day provided. Range of `day` is (1 to 31).

- `hour`

  The hour provided. Range of `hour` is (0 to 23).

- `minute`

  The minute provided. Range of `minute` is (0 to 59).

- `second`

  The second provided. Range of `second` is (0 to 59).

- `milliSeconds`

  The milliseconds provided. Range of `millisecond` is (0 to 999.999999).

Exceptions

`ArgumentOutOfRangeException` - The argument value for one or more of the parameters is out of the specified range.

`ArgumentException` - The argument values of the parameters cannot be used to construct a valid `OracleTimeStampLTZ` (that is, the day is out of range for the month).

See Also: "Oracle.DataAccess.Types Namespace" OracleTimeStampLTZ Structure OracleTimeStampLTZ Members

### OracleTimeStampLTZ(int, int, int, int, int, int, int)

This constructor creates a new instance of the `OracleTimeStampLTZ` structure and sets its value for date and time using year, month, day, hour, minute, second, and nanosecond.

Declaration

    // C#
    public OracleTimeStampLTZ (int year, int month, int day, int hour,
      int minute, int second, int nanosecond);

Parameters

- `year`

  The year provided. Range of `year` is (-4712 to 9999).

- `month`

  The month provided. Range of `month` is (1 to 12).

- `day`

  The day provided. Range of `day` is (1 to 31).

- `hour`

  The hour provided. Range of `hour` is (0 to 23).

- `minute`

  The minute provided. Range of `minute` is (0 to 59).

- `second`

  The second provided. Range of `second` is (0 to 59).

- `nanosecond`

  The nanosecond provided. Range of `nanosecond` is (0 to 999999999).

Exceptions

`ArgumentOutOfRangeException` - The argument value for one or more of the parameters is out of the specified range.

`ArgumentException` - The argument values of the parameters cannot be used to construct a valid `OracleTimeStampLTZ` (that is, the day is out of range for the month).

See Also: "Oracle.DataAccess.Types Namespace" OracleTimeStampLTZ Structure OracleTimeStampLTZ Members

### OracleTimeStampLTZ(byte [ ])

This constructor creates a new instance of the `OracleTimeStampLTZ` structure and sets its value to the provided byte array, which is in the internal Oracle `TIMESTAMP` `WITH` `LOCAL` `TIME` `ZONE` format.

Declaration

    // C#
    public OracleTimeStampLTZ (byte[] bytes);

Parameters

- `bytes`

  A byte array that represents an Oracle `TIMESTAMP` `WITH` `LOCAL` `TIME` `ZONE` in Oracle internal format.

Exceptions

`ArgumentException` - `bytes` is not in an internal Oracle `TIMESTAMP` `WITH` `LOCAL` `TIME` `ZONE` format or `bytes` is not a valid Oracle `TIMESTAMP` `WITH` `LOCAL` `TIME` `ZONE`.

`ArgumentNullException` - `bytes` is null.

See Also: "Oracle.DataAccess.Types Namespace" OracleTimeStampLTZ Structure OracleTimeStampLTZ Members

## OracleTimeStampLTZ Static Fields

The `OracleTimeStampLTZ` static fields are listed in Table 11-107.

Table 11-107 OracleTimeStampLTZ Static Fields

Field | Description
--- | ---
MaxValue | Represents the maximum valid date for an `OracleTimeStampLTZ` structure, which is December 31, 9999 23:59:59.999999999
MinValue | Represents the minimum valid date for an `OracleTimeStampLTZ` structure, which is January 1, -4712 0:0:0
Null | Represents a null value that can be assigned to an instance of the `OracleTimeStampLTZ` structure

See Also: "Oracle.DataAccess.Types Namespace" OracleTimeStampLTZ Structure OracleTimeStampLTZ Members

### MaxValue

This static field represents the maximum valid date for an `OracleTimeStampLTZ` structure, which is December 31, 9999 23:59:59.999999999.

Declaration

    // C#
    public static readonly OracleTimeStampLTZ MaxValue;

Remarks

This value is the maximum date and time in the client time zone.

See Also: "Oracle.DataAccess.Types Namespace" OracleTimeStampLTZ Structure OracleTimeStampLTZ Members

### MinValue

This static field represents the minimum valid date for an `OracleTimeStampLTZ` structure, which is January 1, -4712 0:0:0.

Declaration

    // C#
    public static readonly OracleTimeStampLTZ MinValue;

Remarks

This value is the minimum date and time in the client time zone.

See Also: "Oracle.DataAccess.Types Namespace" OracleTimeStampLTZ Structure OracleTimeStampLTZ Members

### Null

This static field represents a null value that can be assigned to an instance of the `OracleTimeStampLTZ` structure.

Declaration

    // C#
    public static readonly OracleTimeStampLTZ Null;

See Also: "Oracle.DataAccess.Types Namespace" OracleTimeStampLTZ Structure OracleTimeStampLTZ Members

## OracleTimeStampLTZ Static Methods

The `OracleTimeStampLTZ` static methods are listed in Table 11-108.

Table 11-108 OracleTimeStampLTZ Static Methods

Methods | Description
--- | ---
Equals | Determines if two `OracleTimeStampLTZ` values are equal (Overloaded)
GetLocalTimeZoneName | Gets the client's local time zone name
GetLocalTimeZoneOffset | Gets the client's local time zone offset relative to UTC
GetSysDate | Gets an `OracleTimeStampLTZ` structure that represents the current date and time
GreaterThan | Determines if the first of two `OracleTimeStampLTZ` values is greater than the second
GreaterThanOrEqual | Determines if the first of two `OracleTimeStampLTZ` values is greater than or equal to the second
LessThan | Determines if the first of two `OracleTimeStampLTZ` values is less than the second
LessThanOrEqual | Determines if the first of two `OracleTimeStampLTZ` values is less than or equal to the second
NotEquals | Determines if two `OracleTimeStampLTZ` values are not equal
Parse | Gets an `OracleTimeStampLTZ` structure and sets its value for date and time using the supplied string
SetPrecision | Returns a new instance of an `OracleTimeStampLTZ` with the specified fractional second precision

See Also: "Oracle.DataAccess.Types Namespace" OracleTimeStampLTZ Structure OracleTimeStampLTZ Members

### Equals

This static method determines if two `OracleTimeStampLTZ` values are equal.

Declaration

    // C#
    public static bool Equals(OracleTimeStampLTZ value1,
      OracleTimeStampLTZ value2);

Parameters

- `value1`

  The first `OracleTimeStampLTZ`.

- `value2`

  The second `OracleTimeStampLTZ`.

Return Value

Returns `true` if two `OracleTimeStampLTZ` values are equal. Returns `false` otherwise.

Remarks

The following rules apply to the behavior of this method.

- Any `OracleTimeStampLTZ` that has a value is greater than an `OracleTimeStampLTZ` that has a null value.

- Two `OracleTimeStampLTZ`s that contain a null value are equal.

See Also: "Oracle.DataAccess.Types Namespace" OracleTimeStampLTZ Structure OracleTimeStampLTZ Members

### GetLocalTimeZoneName

This static method gets the client's local time zone name.

Declaration

    // C#
    public static string GetLocalTimeZoneName();

Return Value

A string containing the local time zone.

See Also: "Oracle.DataAccess.Types Namespace" OracleTimeStampLTZ Structure OracleTimeStampLTZ Members

### GetLocalTimeZoneOffset

This static method gets the client's local time zone offset relative to Coordinated Universal Time (UTC).

Declaration

    // C#
    public static TimeSpan GetLocalTimeZoneOffset( );

Return Value

A `TimeSpan` structure containing the local time zone hours and time zone minutes.

See Also: "Oracle.DataAccess.Types Namespace" OracleTimeStampLTZ Structure OracleTimeStampLTZ Members

### GetSysDate

This static method gets an `OracleTimeStampLTZ` structure that represents the current date and time.

Declaration

    // C#
    public static OracleTimeStampLTZ GetSysDate();

Return Value

An `OracleTimeStampLTZ` structure that represents the current date and time.

See Also: "Oracle.DataAccess.Types Namespace" OracleTimeStampLTZ Structure OracleTimeStampLTZ Members

### GreaterThan

This static method determines if the first of two `OracleTimeStampLTZ` values is greater than the second.

Declaration

    // C#
    public static bool GreaterThan(OracleTimeStampLTZ value1,
       OracleTimeStampLTZ value2);

Parameters

- `value1`

  The first `OracleTimeStampLTZ`.

- `value2`

  The second `OracleTimeStampLTZ`.

Return Value

Returns `true` if the first of two `OracleTimeStampLTZ` values is greater than the second; otherwise, returns `false`.

Remarks

The following rules apply to the behavior of this method.

- Any `OracleTimeStampLTZ` that has a value is greater than an `OracleTimeStampLTZ` that has a null value.

- Two `OracleTimeStampLTZ`s that contain a null value are equal.

See Also: "Oracle.DataAccess.Types Namespace" OracleTimeStampLTZ Structure OracleTimeStampLTZ Members

### GreaterThanOrEqual

This static method determines if the first of two `OracleTimeStampLTZ` values is greater than or equal to the second.

Declaration

    // C#
    public static bool GreaterThanOrEqual(OracleTimeStampLTZ value1,
      OracleTimeStampLTZ value2);

Parameters

- `value1`

  The first `OracleTimeStampLTZ`.

- `value2`

  The second `OracleTimeStampLTZ`.

Return Value

Returns `true` if the first of two `OracleTimeStampLTZ` values is greater than or equal to the second; otherwise, returns `false`.

Remarks

The following rules apply to the behavior of this method.

- Any `OracleTimeStampLTZ` that has a value is greater than an `OracleTimeStampLTZ` that has a null value.

- Two `OracleTimeStampLTZ`s that contain a null value are equal.

See Also: "Oracle.DataAccess.Types Namespace" OracleTimeStampLTZ Structure OracleTimeStampLTZ Members

### LessThan

This static method determines if the first of two `OracleTimeStampLTZ` values is less than the second.

Declaration

    // C#
    public static bool LessThan(OracleTimeStampLTZ value1,
      OracleTimeStampLTZ value2);

Parameters

- `value1`

  The first `OracleTimeStampLTZ`.

- `value2`

  The second `OracleTimeStampLTZ`.

Return Value

Returns `true` if the first of two `OracleTimeStampLTZ` values is less than the second. Returns `false` otherwise.

Remarks

The following rules apply to the behavior of this method.

- Any `OracleTimeStampLTZ` that has a value is greater than an `OracleTimeStampLTZ` that has a null value.

- Two `OracleTimeStampLTZ`s that contain a null value are equal.

See Also: "Oracle.DataAccess.Types Namespace" OracleTimeStampLTZ Structure OracleTimeStampLTZ Members

### LessThanOrEqual

This static method determines if the first of two `OracleTimeStampLTZ` values is less than or equal to the second.

Declaration

    // C#
    public static bool LessThanOrEqual(OracleTimeStampLTZ value1,
      OracleTimeStampLTZ value2);

Parameters

- `value1`

  The first `OracleTimeStampLTZ`.

- `value2`

  The second `OracleTimeStampLTZ`.

Return Value

Returns `true` if the first of two `OracleTimeStampLTZ` values is less than or equal to the second. Returns `false` otherwise.

Remarks

The following rules apply to the behavior of this method.

- Any `OracleTimeStampLTZ` that has a value is greater than an `OracleTimeStampLTZ` that has a null value.

- Two `OracleTimeStampLTZ`s that contain a null value are equal.

See Also: "Oracle.DataAccess.Types Namespace" OracleTimeStampLTZ Structure OracleTimeStampLTZ Members

### NotEquals

This static method determines if two `OracleTimeStampLTZ` values are not equal.

Declaration

    // C#
    public static bool NotEquals(OracleTimeStampLTZ value1,
       OracleTimeStampLTZ value2);

Parameters

- `value1`

  The first `OracleTimeStampLTZ`.

- `value2`

  The second `OracleTimeStampLTZ`.

Return Value

Returns `true` if two `OracleTimeStampLTZ` values are not equal. Returns `false` otherwise.

Remarks

The following rules apply to the behavior of this method.

- Any `OracleTimeStampLTZ` that has a value is greater than an `OracleTimeStampLTZ` that has a null value.

- Two `OracleTimeStampLTZ`s that contain a null value are equal.

See Also: "Oracle.DataAccess.Types Namespace" OracleTimeStampLTZ Structure OracleTimeStampLTZ Members

### Parse

This static method creates an `OracleTimeStampLTZ` structure and sets its value using the supplied string.

Declaration

    // C#
    public static OracleTimeStampLTZ Parse(string tsStr);

Parameters

- `tsStr`

  A string that represents an Oracle `TIMESTAMP` `WITH` `LOCAL` `TIME` `ZONE`.

Return Value

An `OracleTimeStampLTZ` structure.

Exceptions

`ArgumentException` - The `tsStr` parameter is an invalid string representation of an Oracle `TIMESTAMP` `WITH` `LOCAL` `TIME` `ZONE` or the `tsStr` is not in the timestamp format specified by the `OracleGlobalization`.`TimeStampFormat` property of the thread, which represents the Oracle `NLS_TIMESTAMP_FORMAT` parameter.

`ArgumentNullException` - The `tsStr` value is null.

Remarks

The names and abbreviations used for months and days are in the language specified by the `DateLanguage` and `Calendar` properties of the thread's `OracleGlobalization` object. If any of the thread's globalization properties are set to null or an empty string, the client computer's settings are used.

Example

    // C#

    using System;
    using Oracle.DataAccess.Types;
    using Oracle.DataAccess.Client;

    class ParseSample
    {
      static void Main()
      {
        // Set the nls_timestamp_format for the Parse() method
        OracleGlobalization info = OracleGlobalization.GetClientInfo();
        info.TimeStampFormat = "DD-MON-YYYY HH:MI:SS.FF AM";
        OracleGlobalization.SetThreadInfo(info);

        // construct OracleTimeStampLTZ from a string using the format specified.
        OracleTimeStampLTZ ts =
          OracleTimeStampLTZ.Parse("11-NOV-1999 11:02:33.444 AM");

        // Set the nls_timestamp_format for the ToString() method
        info.TimeStampFormat = "YYYY-MON-DD HH:MI:SS.FF AM";
        OracleGlobalization.SetThreadInfo(info);

        // Prints "1999-NOV-11 11:02:33.444000000 AM"
        Console.WriteLine(ts.ToString());
      }
    }

See Also: "Oracle.DataAccess.Types Namespace" OracleTimeStampLTZ Structure OracleTimeStampLTZ Members "OracleGlobalization Class" "Globalization Support"

### SetPrecision

This static method returns a new instance of an `OracleTimeStampLTZ` with the specified fractional second precision.

Declaration

    // C#
    public static OracleTimeStampLTZ SetPrecision(OracleTimeStampLTZ value1,
         int fracSecPrecision);

Parameters

- `value1`

  The provided `OracleTimeStampLTZ` object.

- `fracSecPrecision`

  The fractional second precision provided. Range of fractional second precision is (0 to 9).

Return Value

An `OracleTimeStampLTZ` structure with the specified fractional second precision

Exceptions

`ArgumentOutOfRangeException` - `fracSecPrecision` is out of the specified range.

Remarks

The value specified in the supplied `fracSecPrecision` parameter is used to perform a rounding off operation on the supplied `OracleTimeStampLTZ` value. Depending on this value, `0` or more trailing zeros are displayed in the string returned by `ToString()`.

Example

The `OracleTimeStampLTZ` with a value of "`December` `31,` `9999` `23:59:59.99`" results in the string "`December` `31,` `9999` `23:59:59.99000`" when `SetPrecision()` is called with the fractional second precision set to `5`.

See Also: "Oracle.DataAccess.Types Namespace" OracleTimeStampLTZ Structure OracleTimeStampLTZ Members

## OracleTimeStampLTZ Static Operators

The `OracleTimeStampLTZ` static operators are listed in Table 11-109.

Table 11-109 OracleTimeStampLTZ Static Operators

Operator | Description
--- | ---
operator+ | Adds the supplied instance value to the supplied `OracleTimeStampLTZ` and returns a new `OracleTimeStampLTZ` structure (Overloaded)
operator == | Determines if two `OracleTimeStampLTZ` values are equal
operator > | Determines if the first of two `OracleTimeStampLTZ` values is greater than the second
operator >= | Determines if the first of two `OracleTimeStampLTZ` values is greater than or equal to the second
operator != | Determines if two `OracleTimeStampLTZ` values are not equal
operator < | Determines if the first of two `OracleTimeStampLTZ` values is less than the second
operator <= | Determines if the first of two `OracleTimeStampLTZ` values is less than or equal to the second
operator - | Subtracts the supplied instance value from the supplied `OracleTimeStampLTZ` and returns a new `OracleTimeStampLTZ` structure (Overloaded)

See Also: "Oracle.DataAccess.Types Namespace" OracleTimeStampLTZ Structure OracleTimeStampLTZ Members

### operator+

`operator+` adds the supplied value to the supplied `OracleTimeStampLTZ` and returns a new `OracleTimeStampLTZ` structure.

Overload List:

- operator + (OracleTimeStampLTZ, OracleIntervalDS)

  This static operator adds the supplied `OracleIntervalDS` to the supplied `OracleTimeStampLTZ` and returns a new `OracleTimeStampLTZ` structure.

- operator + (OracleTimeStampLTZ, OracleIntervalYM)

  This static operator adds the supplied `OracleIntervalYM` to the supplied `OracleTimeStampLTZ` and returns a new `OracleTimeStampLTZ` structure.

- operator + (OracleTimeStampLTZ, TimeSpan)

  This static operator adds the supplied `TimeSpan` to the supplied `OracleTimeStampLTZ` and returns a new `OracleTimeStampLTZ` structure.

See Also: "Oracle.DataAccess.Types Namespace" OracleTimeStampLTZ Structure OracleTimeStampLTZ Members

### operator + (OracleTimeStampLTZ, OracleIntervalDS)

This static operator adds the supplied `OracleIntervalDS` to the supplied `OracleTimeStampLTZ` and returns a new `OracleTimeStampLTZ` structure.

Declaration

    // C#
    public static operator +(OracleTimeStampLTZ value1,
      OracleIntervalDS value2);

Parameters

- `value1`

  An `OracleTimeStampLTZ`.

- `value2`

  An `OracleIntervalDS.`

Return Value

An `OracleTimeStampLTZ.`

Remarks

If either parameter has a null value, the returned `OracleTimeStampLTZ` has a null value.

See Also: "Oracle.DataAccess.Types Namespace" OracleTimeStampLTZ Structure OracleTimeStampLTZ Members

### operator + (OracleTimeStampLTZ, OracleIntervalYM)

This static operator adds the supplied `OracleIntervalYM` to the supplied `OracleTimeStampLTZ` and returns a new `OracleTimeStampLTZ` structure.

Declaration

    // C#
    public static operator +(OracleTimeStampLTZ value1,
      OracleIntervalYM value2);

Parameters

- `value1`

  An `OracleTimeStampLTZ`.

- `value2`

  An `OracleIntervalYM`.

Return Value

An `OracleTimeStampLTZ`.

Remarks

If either parameter has a null value, the returned `OracleTimeStampLTZ` has a null value.

See Also: "Oracle.DataAccess.Types Namespace" OracleTimeStampLTZ Structure OracleTimeStampLTZ Members

### operator + (OracleTimeStampLTZ, TimeSpan)

This static operator adds the supplied `TimeSpan` to the supplied `OracleTimeStampLTZ` and returns a new `OracleTimeStampLTZ` structure.

Declaration

    // C#
    public static operator +(OracleTimeStampLTZ value1, TimeSpan value2);

Parameters

- `value1`

  An `OracleTimeStampLTZ`.

- `value2`

  A `TimeSpan`.

Return Value

An `OracleTimeStampLTZ.`

Remarks

If the `OracleTimeStampLTZ` instance has a null value, the returned `OracleTimeStampLTZ` has a null value.

See Also: "Oracle.DataAccess.Types Namespace" OracleTimeStampLTZ Structure OracleTimeStampLTZ Members

### operator ==

This static operator determines if two `OracleTimeStampLTZ` values are equal.

Declaration

    // C#
    public static bool operator == (OracleTimeStampLTZ value1,
      OracleTimeStampLTZ  value2);

Parameters

- `value1`

  The first `OracleTimeStampLTZ`.

- `value2`

  The second `OracleTimeStampLTZ`.

Return Value

Returns `true` if they are the same; otherwise, returns `false`.

Remarks

The following rules apply to the behavior of this method.

- Any `OracleTimeStampLTZ` that has a value is greater than an `OracleTimeStampLTZ` that has a null value.

- Two `OracleTimeStampLTZ`s that contain a null value are equal.

See Also: "Oracle.DataAccess.Types Namespace" OracleTimeStampLTZ Structure OracleTimeStampLTZ Members

### operator >

This static operator determines if the first of two `OracleTimeStampLTZ` values is greater than the second.

Declaration

    // C#
    public static bool operator > (OracleTimeStampLTZ value1,
         OracleTimeStampLTZ value2);

Parameters

- `value1`

  The first `OracleTimeStampLTZ`.

- `value2`

  The second `OracleTimeStampLTZ`.

Return Value

Returns `true` if the first `OracleTimeStampLTZ` value is greater than the second; otherwise, returns `false`.

Remarks

The following rules apply to the behavior of this method.

- Any `OracleTimeStampLTZ` that has a value is greater than an `OracleTimeStampLTZ` that has a null value.

- Two `OracleTimeStampLTZ`s that contain a null value are equal.

See Also: "Oracle.DataAccess.Types Namespace" OracleTimeStampLTZ Structure OracleTimeStampLTZ Members

### operator >=

This static operator determines if the first of two `OracleTimeStampLTZ` values is greater than or equal to the second.

Declaration

    // C#
    public static bool operator >= (OracleTimeStampLTZ value1,
        OracleTimeStampLTZ value2);

Parameters

- `value1`

  An `OracleTimeStampLTZ`.

- `value2`

  The second `OracleTimeStampLTZ`.

Return Value

Returns `true` if the first `OracleTimeStampLTZ` is greater than or equal to the second; otherwise, returns `false`.

Remarks

The following rules apply to the behavior of this method.

- Any `OracleTimeStampLTZ` that has a value is greater than an `OracleTimeStampLTZ` that has a null value.

- Two `OracleTimeStampLTZ`s that contain a null value are equal.

See Also: "Oracle.DataAccess.Types Namespace" OracleTimeStampLTZ Structure OracleTimeStampLTZ Members

### operator !=

This static operator determines if two `OracleTimeStampLTZ` values are not equal.

Declaration

    // C#
    public static bool operator != (OracleTimeStampLTZ value1,
        OracleTimeStampLTZ value2);

Parameters

- `value1`

  The first `OracleTimeStampLTZ`.

- `value2`

  The second `OracleTimeStampLTZ`.

Return Value

Returns `true` if two `OracleTimeStampLTZ` values are not equal; otherwise returns `false`.

Remarks

The following rules apply to the behavior of this method.

- Any `OracleTimeStampLTZ` that has a value is greater than an `OracleTimeStampLTZ` that has a null value.

- Two `OracleTimeStampLTZ`s that contain a null value are equal.

See Also: "Oracle.DataAccess.Types Namespace" OracleTimeStampLTZ Structure OracleTimeStampLTZ Members

### operator <

This static operator determines if the first of two `OracleTimeStampLTZ` values is less than the second.

Declaration

    // C#
    public static bool operator < (OracleTimeStampLTZ value1,
         OracleTimeStampLTZ value2);

Parameters

- `value1`

  The first `OracleTimeStampLTZ`.

- `value2`

  The second `OracleTimeStampLTZ`.

Return Value

Returns `true` if the first `OracleTimeStampLTZ` is less than the second; otherwise, returns `false`.

Remarks

The following rules apply to the behavior of this method.

- Any `OracleTimeStampLTZ` that has a value is greater than an `OracleTimeStampLTZ` that has a null value.

- Two `OracleTimeStampLTZ`s that contain a null value are equal.

See Also: "Oracle.DataAccess.Types Namespace" OracleTimeStampLTZ Structure OracleTimeStampLTZ Members

### operator <=

This static operator determines if the first of two `OracleTimeStampLTZ` values is less than or equal to the second.

Declaration

    // C#
    public static bool operator <= (OracleTimeStampLTZ value1,
         OracleTimeStampLTZ value2);

Parameters

- `value1`

  The first `OracleTimeStampLTZ`.

- `value2`

  The second `OracleTimeStampLTZ`.

Return Value

Returns `true` if the first `OracleTimeStampLTZ` is less than or equal to the second; otherwise, returns `false`.

Remarks

The following rules apply to the behavior of this method.

- Any `OracleTimeStampLTZ` that has a value is greater than an `OracleTimeStampLTZ` that has a null value.

- Two `OracleTimeStampLTZ`s that contain a null value are equal.

See Also: "Oracle.DataAccess.Types Namespace" OracleTimeStampLTZ Structure OracleTimeStampLTZ Members

### operator -

`operator-` subtracts the supplied value, from the supplied `OracleTimeStampLTZ` value, and returns a new `OracleTimeStampLTZ` structure.

Overload List:

- operator - (OracleTimeStampLTZ, OracleIntervalDS)

  This static operator subtracts the supplied `OracleIntervalDS` value, from the supplied `OracleTimeStampLTZ` value, and return a new `OracleTimeStampLTZ` structure.

- operator - (OracleTimeStampLTZ, OracleIntervalYM)

  This static operator subtracts the supplied `OracleIntervalYM` value, from the supplied `OracleTimeStampLTZ` value, and returns a new `OracleTimeStampLTZ` structure.

- operator - (OracleTimeStampLTZ, TimeSpan)

  This static operator subtracts the supplied `TimeSpan` value, from the supplied `OracleTimeStampLTZ` value, and returns a new `OracleTimeStampLTZ` structure.

See Also: "Oracle.DataAccess.Types Namespace" OracleTimeStampLTZ Structure OracleTimeStampLTZ Members

### operator - (OracleTimeStampLTZ, OracleIntervalDS)

This static operator subtracts the supplied `OracleIntervalDS` value, from the supplied `OracleTimeStampLTZ` value, and return a new `OracleTimeStampLTZ` structure.

Declaration

    // C#
    public static operator - (OracleTimeStampLTZ value1,
      OracleIntervalDS value2);

Parameters

- `value1`

  An `OracleTimeStampLTZ`.

- `value2`

  An `OracleIntervalDS` instance.

Return Value

An `OracleTimeStampLTZ` structure.

Remarks

If either parameter has a null value, the returned `OracleTimeStampLTZ` has a null value.

See Also: "Oracle.DataAccess.Types Namespace" OracleTimeStampLTZ Structure OracleTimeStampLTZ Members

### operator - (OracleTimeStampLTZ, OracleIntervalYM)

This static operator subtracts the supplied `OracleIntervalYM` value, from the supplied `OracleTimeStampLTZ` value, and returns a new `OracleTimeStampLTZ` structure.

Declaration

    // C#
    public static operator - (OracleTimeStampLTZ value1,
      OracleIntervalYM value2);

Parameters

- `value1`

  An `OracleTimeStampLTZ`.

- `value2`

  An `OracleIntervalYM`.

Return Value

An `OracleTimeStampLTZ` structure.

Remarks

If either parameter has a null value, the returned `OracleTimeStampLTZ` has a null value.

See Also: "Oracle.DataAccess.Types Namespace" OracleTimeStampLTZ Structure OracleTimeStampLTZ Members

### operator - (OracleTimeStampLTZ, TimeSpan)

This static operator subtracts the supplied `TimeSpan` value, from the supplied `OracleTimeStampLTZ` value, and returns a new `OracleTimeStampLTZ` structure.

Declaration

    // C#
    public static operator -(OracleTimeStampLTZ value1, TimeSpan value2);

Parameters

- `value1`

  An `OracleTimeStampLTZ`.

- `value2`

  A `TimeSpan`.

Return Value

An `OracleTimeStampLTZ` structure.

Remarks

If the `OracleTimeStampLTZ` instance has a null value, the returned `OracleTimeStampLTZ` structure has a null value.

See Also: "Oracle.DataAccess.Types Namespace" OracleTimeStampLTZ Structure OracleTimeStampLTZ Members

## OracleTimeStampLTZ Static Type Conversions

The `OracleTimeStampLTZ` static type conversions are listed in Table 11-110.

Table 11-110 OracleTimeStampLTZ Static Type Conversions

Operator | Description
--- | ---
explicit operator OracleTimeStampLTZ | Converts an instance value to an `OracleTimeStampLTZ` structure (Overloaded)
implicit operator OracleTimeStampLTZ | Converts an instance value to an `OracleTimeStampLTZ` structure (Overloaded)
explicit operator DateTime | Converts an `OracleTimeStampLTZ` value to a `DateTime` structure

See Also: "Oracle.DataAccess.Types Namespace" OracleTimeStampLTZ Structure OracleTimeStampLTZ Members

### explicit operator OracleTimeStampLTZ

`explicit operator OracleTimeStampLTZ` converts the supplied value to an `OracleTimeStampLTZ` structure.

Overload List:

- explicit operator OracleTimeStampLTZ(OracleTimeStamp)

  This static type conversion operator converts an `OracleTimeStamp` value to an `OracleTimeStampLTZ` structure.

- explicit operator OracleTimeStampLTZ(OracleTimeStampTZ)

  This static type conversion operator converts an `OracleTimeStampTZ` value to an `OracleTimeStampLTZ` structure.

- explicit operator OracleTimeStampLTZ(string)

  This static type conversion operator converts the supplied string to an `OracleTimeStampLTZ` structure.

See Also: "Oracle.DataAccess.Types Namespace" OracleTimeStampLTZ Structure OracleTimeStampLTZ Members

### explicit operator OracleTimeStampLTZ(OracleTimeStamp)

This static type conversion operator converts an `OracleTimeStamp` value to an `OracleTimeStampLTZ` structure.

Declaration

    // C#
    public static explicit operator OracleTimeStampLTZ (OracleTimeStamp value1);

Parameters

- `value1`

  An `OracleTimeStamp`.

Return Value

The `OracleTimeStampLTZ` structure contains the date and time of the `OracleTimeStampTZ` structure.

Remarks

If the `OracleTimeStamp` structure has a null value, the returned `OracleTimeStampLTZ` structure also has a null value.

See Also: "Oracle.DataAccess.Types Namespace" OracleTimeStampLTZ Structure OracleTimeStampLTZ Members

### explicit operator OracleTimeStampLTZ(OracleTimeStampTZ)

This static type conversion operator converts an `OracleTimeStampTZ` value to an `OracleTimeStampLTZ` structure.

Declaration

    // C#
    public static explicit operator OracleTimeStampLTZ
      (OracleTimeStampTZ value1);

Parameters

- `value1`

  An `OracleTimeStampTZ` instance.

Return Value

The `OracleTimeStampLTZ` structure contains the date and time in the `OracleTimeStampTZ` structure (which is normalized to the client local time zone).

Remarks

If the `OracleTimeStampTZ` structure has a null value, the returned `OracleTimeStampLTZ` structure also has a null value.

See Also: "Oracle.DataAccess.Types Namespace" OracleTimeStampLTZ Structure OracleTimeStampLTZ Members

### explicit operator OracleTimeStampLTZ(string)

This static type conversion operator converts the supplied string to an `OracleTimeStampLTZ` structure.

Declaration

    // C#
    public static explicit operator OracleTimeStampLTZ (string tsStr);

Parameters

- `tsStr`

  A string representation of an Oracle `TIMESTAMP` `WITH` `LOCAL` `TIME` `ZONE`.

Return Value

A `OracleTimeStampLTZ`.

Exceptions

`ArgumentException` - The`tsStr` parameter is an invalid string representation of an Oracle `TIMESTAMP` `WITH` `LOCAL` `TIME` `ZONE` or the `tsStr` is not in the timestamp format specified by the thread's `OracleGlobalization`.`TimeStampFormat` property, which represents the Oracle `NLS_TIMESTAMP_FORMAT` parameter.

Remarks

The names and abbreviations used for months and days are in the language specified by the `DateLanguage` and `Calendar` properties of the thread's `OracleGlobalization` object. If any of the thread's globalization properties are set to null or an empty string, the client computer's settings are used.

Example

    // C#

    using System;
    using Oracle.DataAccess.Types;
    using Oracle.DataAccess.Client;

    class OracleTimeStampLTZSample
    {
      static void Main()
      {
        // Set the nls_timestamp_format for the OracleTimeStampLTZ(string)
        // constructor
        OracleGlobalization info = OracleGlobalization.GetClientInfo();
        info.TimeStampFormat = "DD-MON-YYYY HH:MI:SS.FF AM";
        OracleGlobalization.SetThreadInfo(info);

        // construct OracleTimeStampLTZ from a string using the format specified.
        OracleTimeStampLTZ ts =
          new OracleTimeStampLTZ("11-NOV-1999 11:02:33.444 AM");

        // Set the nls_timestamp_format for the ToString() method
        info.TimeStampFormat = "YYYY-MON-DD HH:MI:SS.FF AM";
        OracleGlobalization.SetThreadInfo(info);

        // Prints "1999-NOV-11 11:02:33.444000000 AM"
        Console.WriteLine(ts.ToString());
      }
    }

See Also: "Oracle.DataAccess.Types Namespace" OracleTimeStampLTZ Structure OracleTimeStampLTZ Members "OracleGlobalization Class" "Globalization Support" Oracle Database SQL Reference for further information on datetime format elements

### implicit operator OracleTimeStampLTZ

`implicit operator OracleTimeStampLTZ` converts the supplied structure to an `OracleTimeStampLTZ` structure.

Overload List:

- implicit operator OracleTimeStampLTZ(OracleDate)

  This static type conversion operator converts an `OracleDate` value to an `OracleTimeStampLTZ` structure.

- implicit operator OracleTimeStampLTZ(DateTime)

  This static type conversion operator converts a `DateTime` structure to an `OracleTimeStampLTZ` structure.

See Also: "Oracle.DataAccess.Types Namespace" OracleTimeStampLTZ Structure OracleTimeStampLTZ Members

### implicit operator OracleTimeStampLTZ(OracleDate)

This static type conversion operator converts an `OracleDate` value to an `OracleTimeStampLTZ` structure.

Declaration

    // C#
    public static implicit operator OracleTimeStampLTZ(OracleDate value1);

Parameters

- `value1`

  An `OracleDate`.

Return Value

The returned `OracleTimeStampLTZ` structure contains the date and time in the `OracleDate` structure.

Remarks

If the `OracleDate` structure has a null value, the returned `OracleTimeStampLTZ` structure also has a null value.

See Also: "Oracle.DataAccess.Types Namespace" OracleTimeStampLTZ Structure OracleTimeStampLTZ Members

### implicit operator OracleTimeStampLTZ(DateTime)

This static type conversion operator converts a `DateTime` structure to an `OracleTimeStampLTZ` structure.

Declaration

    // C#
    public static implicit operator OracleTimeStampLTZ(DateTime value1);

Parameters

- `value1`

  A `DateTime` structure.

Return Value

An `OracleTimeStampLTZ` structure.

See Also: "Oracle.DataAccess.Types Namespace" OracleTimeStampLTZ Structure OracleTimeStampLTZ Members

### explicit operator DateTime

This static type conversion operator converts an `OracleTimeStampLTZ` value to a `DateTime` structure.

Declaration

    // C#
    public static explicit operator DateTime(OracleTimeStampLTZ value1);

Parameters

- `value1`

  An `OracleTimeStampLTZ` instance.

Return Value

A `DateTime` that contains the date and time in the current instance.

Exceptions

`OracleNullValueException` - The `OracleTimeStampLTZ` structure has a null value.

Remarks

The precision of the `OracleTimeStampLTZ` value can be lost during the conversion.

See Also: "Oracle.DataAccess.Types Namespace" OracleTimeStampLTZ Structure OracleTimeStampLTZ Members

## OracleTimeStampLTZ Properties

The `OracleTimeStampLTZ` properties are listed in Table 11-111.

Table 11-111 OracleTimeStampLTZ Properties

Properties | Description
--- | ---
BinData | Returns an array of bytes that represents an `Oracle TIMESTAMP` `WITH` `LOCAL` `TIME` `ZONE` in Oracle internal format
Day | Specifies the `day` component of an `OracleTimeStampLTZ`
IsNull | Indicates whether or not the `OracleTimeStampLTZ` instance has a null value
Hour | Specifies the hour component of an `OracleTimeStampLTZ`
Millisecond | Specifies the millisecond component of an `OracleTimeStampLTZ`
Minute | Specifies the minute component of an `OracleTimeStampLTZ`
Month | Specifies the month component of an `OracleTimeStampLTZ`
Nanosecond | Specifies the nanosecond component of an `OracleTimeStampLTZ`
Second | Specifies the second component of an `OracleTimeStampLTZ`
Value | Specifies the date and time that is stored in the `OracleTimeStampLTZ` structure
Year | Specifies the year component of an `OracleTimeStampLTZ`

See Also: "Oracle.DataAccess.Types Namespace" OracleTimeStampLTZ Structure OracleTimeStampLTZ Members

### BinData

This property returns an array of bytes that represents an Oracle `TIMESTAMP` `WITH` `LOCAL` `TIME` `ZONE` in Oracle internal format.

Declaration

    // C#
    public byte[] BinData {get;}

Property Value

A byte array that represents an Oracle `TIMESTAMP` `WITH` `LOCAL` `TIME` `ZONE` internal format.

Exceptions

`OracleNullValueException` - The current instance has a null value.

See Also: "Oracle.DataAccess.Types Namespace" OracleTimeStampLTZ Structure OracleTimeStampLTZ Members

### Day

This property specifies the day component of an `OracleTimeStampLTZ.`

Declaration

    // C#
    public int Day{get;}

Property Value

A number that represents the day. Range of `Day` is (1 to 31).

Exceptions

`OracleNullValueException` - The current instance has a null value.

See Also: "Oracle.DataAccess.Types Namespace" OracleTimeStampLTZ Structure OracleTimeStampLTZ Members

### IsNull

This property indicates whether or not the current instance has a null value.

Declaration

    // C#
    public bool IsNull{get;}

Property Value

Returns `true` if the current instance contains a null value; otherwise, returns `false`.

See Also: "Oracle.DataAccess.Types Namespace" OracleTimeStampLTZ Structure OracleTimeStampLTZ Members

### Hour

This property specifies the hour component of an `OracleTimeStampLTZ`.

Declaration

    // C#
    public int Hour{get;}

Property Value

A number that represents the hour. Range of `Hour` is (0 to 23).

Exceptions

`OracleNullValueException` - The current instance has a null value.

See Also: "Oracle.DataAccess.Types Namespace" OracleTimeStampLTZ Structure OracleTimeStampLTZ Members

### Millisecond

This property gets the millisecond component of an `OracleTimeStampLTZ`.

Declaration

    // C#
    public double Millisecond{get;}

Property Value

A number that represents a millisecond. Range of `Millisecond` is (0 to 999.999999)

Exceptions

`OracleNullValueException` - The current instance has a null value.

See Also: "Oracle.DataAccess.Types Namespace" OracleTimeStampLTZ Structure OracleTimeStampLTZ Members

### Minute

This property gets the minute component of an `OracleTimeStampLTZ.`

Declaration

    // C#
    public int Minute{get;}

Property Value

A number that represent a minute. Range of `Minute` is (0 to 59).

Exceptions

`OracleNullValueException` - The current instance has a null value.

See Also: "Oracle.DataAccess.Types Namespace" OracleTimeStampLTZ Structure OracleTimeStampLTZ Members

### Month

This property gets the month component of an `OracleTimeStampLTZ`.

Declaration

    // C#
    public int Month{get;}

Property Value

A number that represents a month. Range of `Month` is (1 to 12).

Exceptions

`OracleNullValueException` - The current instance has a null value.

See Also: "Oracle.DataAccess.Types Namespace" OracleTimeStampLTZ Structure OracleTimeStampLTZ Members

### Nanosecond

This property gets the nanosecond component of an `OracleTimeStampLTZ`.

Declaration

    // C#
    public int Nanosecond{get;}

Property Value

A number that represents a nanosecond. Range of `Nanosecond` is (0 to 999999999).

Exceptions

`OracleNullValueException` - The current instance has a null value.

See Also: "Oracle.DataAccess.Types Namespace" OracleTimeStampLTZ Structure OracleTimeStampLTZ Members

### Second

This property gets the second component of an `OracleTimeStampLTZ`.

Declaration

    // C#
    public int Second{get;}

Property Value

A number that represents a second. Range of `Second` is (0 to 59).

Exceptions

`OracleNullValueException` - The current instance has a null value.

See Also: "Oracle.DataAccess.Types Namespace" OracleTimeStampLTZ Structure OracleTimeStampLTZ Members

### Value

This property specifies the date and time that is stored in the `OracleTimeStampLTZ` structure.

Declaration

    // C#
    public DateTime Value{get;}

Property Value

A `DateTime`.

Exceptions

`OracleNullValueException` - The current instance has a null value.

See Also: "Oracle.DataAccess.Types Namespace" OracleTimeStampLTZ Structure OracleTimeStampLTZ Members

### Year

This property gets the year component of an `OracleTimeStampLTZ`.

Declaration

    // C#
    public int Year{get;}

Property Value

A number that represents a year. The range of `Year` is (-4712 to 9999).

Exceptions

`OracleNullValueException` - The current instance has a null value.

See Also: "Oracle.DataAccess.Types Namespace" OracleTimeStampLTZ Structure OracleTimeStampLTZ Members

## OracleTimeStampLTZ Methods

The `OracleTimeStampLTZ` methods are listed in Table 11-112.

Table 11-112 OracleTimeStampLTZ Methods

Methods | Description
--- | ---
AddDays | Adds the supplied number of days to the current instance
AddHours | Adds the supplied number of hours to the current instance
AddMilliseconds | Adds the supplied number of milliseconds to the current instance
AddMinutes | Adds the supplied number of minutes to the current instance
AddMonths | Adds the supplied number of months to the current instance
AddNanoseconds | Adds the supplied number of nanoseconds to the current instance
AddSeconds | Adds the supplied number of seconds to the current instance
AddYears | Adds the supplied number of years to the current instance
CompareTo | Compares the current `OracleTimeStampLTZ` instance to an object and returns an integer that represents their relative values
Equals | Determines whether or not an object has the same date and time as the current `OracleTimeStampLTZ` instance (Overloaded)
GetHashCode | Returns a hash code for the `OracleTimeStampLTZ` instance
GetDaysBetween | Subtracts an `OracleTimeStampLTZ` from the current instance and returns an `OracleIntervalDS` that represents the difference
GetYearsBetween | Subtracts an `OracleTimeStampLTZ` from the current instance and returns an `OracleIntervalYM` that represents the difference
GetType | Inherited from `Object`
ToOracleDate | Converts the current `OracleTimeStampLTZ` structure to an `OracleDate` structure
ToOracleTimeStamp | Converts the current `OracleTimeStampLTZ` structure to an `OracleTimeStamp` structure
ToOracleTimeStampTZ | Converts the current `OracleTimeStampLTZ` structure to an `OracleTimeStampTZ` structure
ToString | Converts the current `OracleTimeStampLTZ` structure to a string
ToUniversalTime | Converts the current local time to Coordinated Universal Time (UTC)

See Also: "Oracle.DataAccess.Types Namespace" OracleTimeStampLTZ Structure OracleTimeStampLTZ Members

### AddDays

This method adds the supplied number of days to the current instance.

Declaration

    // C#
    public OracleTimeStampLTZ AddDays(double days);

Parameters

- `days`

  The supplied number of days. Range is (-1,000,000,000 < `days` < 1,000,000,000)

Return Value

An `OracleTimeStampLTZ`.

Exceptions

`OracleNullValueException` - The current instance has a null value.

`ArgumentOutofRangeException` - The argument value is out of the specified range.

See Also: "Oracle.DataAccess.Types Namespace" OracleTimeStampLTZ Structure OracleTimeStampLTZ Members

### AddHours

This method adds the supplied number of hours to the current instance.

Declaration

    // C#
    public OracleTimeStampLTZ AddHours(double hours);

Parameters

- `hours`

  The supplied number of hours. Range is (-24,000,000,000 < `hours` < 24,000,000,000).

Return Value

An `OracleTimeStampLTZ`.

Exceptions

`OracleNullValueException` - The current instance has a null value.

`ArgumentOutofRangeException` - The argument value is out of the specified range.

See Also: "Oracle.DataAccess.Types Namespace" OracleTimeStampLTZ Structure OracleTimeStampLTZ Members

### AddMilliseconds

This method adds the supplied number of milliseconds to the current instance.

Declaration

    // C#
    public OracleTimeStampLTZ AddMilliseconds(double milliseconds);

Parameters

- `milliseconds`

  The supplied number of milliseconds. Range is (-8.64 * 1016< `milliseconds` < 8.64 * 1016).

Return Value

An `OracleTimeStampLTZ`.

Exceptions

`OracleNullValueException` - The current instance has a null value.

`ArgumentOutofRangeException` - The argument value is out of the specified range.

See Also: "Oracle.DataAccess.Types Namespace" OracleTimeStampLTZ Structure OracleTimeStampLTZ Members

### AddMinutes

This method adds the supplied number of minutes to the current instance.

Declaration

    // C#
    public OracleTimeStampLTZ AddMinutes(double minutes);

Parameters

- `minutes`

  The supplied number of minutes. Range is (-1,440,000,000,000 < `minutes` < 1,440,000,000,000).

Return Value

An `OracleTimeStampLTZ`.

Exceptions

`OracleNullValueException` - The current instance has a null value.

`ArgumentOutofRangeException` - The argument value is out of the specified range.

See Also: "Oracle.DataAccess.Types Namespace" OracleTimeStampLTZ Structure OracleTimeStampLTZ Members

### AddMonths

This method adds the supplied number of months to the current instance.

Declaration

    // C#
    public OracleTimeStampLTZ AddMonths(long months);

Parameters

- `months`

  The supplied number of months. Range is (-12,000,000,000 < `months` < 12,000,000,000).

Return Value

An `OracleTimeStampLTZ`.

Exceptions

`OracleNullValueException` - The current instance has a null value.

`ArgumentOutofRangeException` - The argument value is out of the specified range.

See Also: "Oracle.DataAccess.Types Namespace" OracleTimeStampLTZ Structure OracleTimeStampLTZ Members

### AddNanoseconds

This method adds the supplied number of nanoseconds to the current instance.

Declaration

    // C#
    public OracleTimeStampLTZ AddNanoseconds(long nanoseconds);

Parameters

- `nanoseconds`

  The supplied number of nanoseconds.

Return Value

An `OracleTimeStampLTZ`.

Exceptions

`OracleNullValueException` - The current instance has a null value.

See Also: "Oracle.DataAccess.Types Namespace" OracleTimeStampLTZ Structure OracleTimeStampLTZ Members

### AddSeconds

This method adds the supplied number of seconds to the current instance.

Declaration

    // C#
    public OracleTimeStampLTZ AddSeconds(double seconds);

Parameters

- `seconds`

  The supplied number of seconds. Range is (-8.64 * 1013< `seconds` < 8.64 * 1013).

Return Value

An `OracleTimeStampLTZ`.

Exceptions

`OracleNullValueException` - The current instance has a null value.

`ArgumentOutofRangeException` - The argument value is out of the specified range.

See Also: "Oracle.DataAccess.Types Namespace" OracleTimeStampLTZ Structure OracleTimeStampLTZ Members

### AddYears

This method adds the supplied number of years to the current instance

Declaration

    // C#
    public OracleTimeStampLTZ AddYears(int years);

Parameters

- `years`

  The supplied number of years. Range is (-999,999,999 <= `years` < = 999,999,999)

Return Value

An `OracleTimeStampLTZ`.

Exceptions

`OracleNullValueException` - The current instance has a null value.

`ArgumentOutofRangeException` - The argument value is out of the specified range.

See Also: "Oracle.DataAccess.Types Namespace" OracleTimeStampLTZ Structure OracleTimeStampLTZ Members

### CompareTo

This method compares the current `OracleTimeStampLTZ` instance to an object, and returns an integer that represents their relative values.

Declaration

    // C#
    public int CompareTo(object obj);

Parameters

- `obj`

  The object being compared to the current `OracleTimeStampLTZ` instance.

Return Value

The method returns a number that is:

- Less than zero: if the current `OracleTimeStampLTZ` instance value is less than that of `obj`.

- Zero: if the current `OracleTimeStampLTZ` instance and `obj` values are equal.

- Greater than zero: if the current `OracleTimeStampLTZ` instance value is greater than that of `obj`.

Implements

`IComparable`

Exceptions

`ArgumentException` - The `obj` parameter is not of type `OracleTimeStampLTZ`.

Remarks

The following rules apply to the behavior of this method.

- The comparison must be between `OracleTimeStampLTZ`s. For example, comparing an `OracleTimeStampLTZ` instance with an `OracleBinary` instance is not allowed. When an `OracleTimeStampLTZ` is compared with a different type, an `ArgumentException` is thrown.

- Any `OracleTimeStampLTZ` that has a value is greater than an `OracleTimeStampLTZ` that has a null value.

- Two `OracleTimeStampLTZ`s that contain a null value are equal.

See Also: "Oracle.DataAccess.Types Namespace" OracleTimeStampLTZ Structure OracleTimeStampLTZ Members

### Equals

Overrides `Object`

This method determines whether or not an object has the same date and time as the current `OracleTimeStampLTZ` instance.

Declaration

    // C#
    public override bool Equals(object obj);

Parameters

- `obj`

  The object being compared to the current `OracleTimeStampLTZ` instance.

Return Value

Returns `true` if the `obj` is of type `OracleTimeStampLTZ` and represents the same date and time; otherwise, returns `false`.

Remarks

The following rules apply to the behavior of this method.

- Any `OracleTimeStampLTZ` that has a value is greater than an `OracleTimeStampLTZ` that has a null value.

- Two `OracleTimeStampLTZ`s that contain a null value are equal.

See Also: "Oracle.DataAccess.Types Namespace" OracleTimeStampLTZ Structure OracleTimeStampLTZ Members

### GetHashCode

Overrides `Object`

This method returns a hash code for the `OracleTimeStampLTZ` instance.

Declaration

    // C#
    public override int GetHashCode();

Return Value

A number that represents the hash code.

See Also: "Oracle.DataAccess.Types Namespace" OracleTimeStampLTZ Structure OracleTimeStampLTZ Members

### GetDaysBetween

This method subtracts an `OracleTimeStampLTZ` value from the current instance and returns an `OracleIntervalDS` that represents the difference.

Declaration

    // C#
    public OracleIntervalDS GetDaysBetween(OracleTimeStampLTZ value1);

Parameters

- `value1`

  The `OracleTimeStampLTZ` value being subtracted.

Return Value

An `OracleIntervalDS` that represents the interval between two `OracleTimeStampLTZ` values.

Remarks

If either the current instance or the parameter has a null value, the returned `OracleIntervalDS` has a null value.

See Also: "Oracle.DataAccess.Types Namespace" OracleTimeStampLTZ Structure OracleTimeStampLTZ Members

### GetYearsBetween

This method subtracts an `OracleTimeStampLTZ` value from the current instance and returns an `OracleIntervalYM` that represents the time interval.

Declaration

    // C#
    public OracleIntervalYM GetYearsBetween(OracleTimeStampLTZ value1);

Parameters

- `value1`

  The `OracleTimeStampLTZ` value being subtracted.

Return Value

An `OracleIntervalYM` that represents the interval between two `OracleTimeStampLTZ` values.

Remarks

If either the current instance or the parameter has a null value, the returned `OracleIntervalYM` has a null value.

See Also: "Oracle.DataAccess.Types Namespace" OracleTimeStampLTZ Structure OracleTimeStampLTZ Members

### ToOracleDate

This method converts the current `OracleTimeStampLTZ` structure to an `OracleDate` structure.

Declaration

    // C#
    public OracleDate ToOracleDate();

Return Value

The returned `OracleDate` structure contains the date and time in the current instance.

Remarks

The precision of the `OracleTimeStampLTZ` value can be lost during the conversion.

If the current instance has a null value, the value of the returned `OracleDate` structure has a null value.

See Also: "Oracle.DataAccess.Types Namespace" OracleTimeStampLTZ Structure OracleTimeStampLTZ Members

### ToOracleTimeStamp

This method converts the current `OracleTimeStampLTZ` structure to an `OracleTimeStamp` structure.

Declaration

    // C#
    public OracleTimeStamp ToOracleTimeStamp();

Return Value

The returned `OracleTimeStamp` contains the date and time in the current instance.

Remarks

If the current instance has a null value, the value of the returned `OracleTimeStamp` structure has a null value.

See Also: "Oracle.DataAccess.Types Namespace" OracleTimeStampLTZ Structure OracleTimeStampLTZ Members

### ToOracleTimeStampTZ

This method converts the current `OracleTimeStampLTZ` structure to an `OracleTimeStampTZ` structure.

Declaration

    // C#
    public OracleTimeStampTZ ToOracleTimeStampTZ();

Return Value

The returned `OracleTimeStampTZ` contains the date and time of the current instance, with the time zone set to the `OracleGlobalization.TimeZone` from the thread.

Remarks

If the current instance has a null value, the value of the returned `OracleTimeStampTZ` structure has a null value.

See Also: "Oracle.DataAccess.Types Namespace" OracleTimeStampLTZ Structure OracleTimeStampLTZ Members "OracleGlobalization Class" "Globalization Support"

### ToString

Overrides `Object`

This method converts the current `OracleTimeStampLTZ` structure to a string.

Declaration

    // C#
    public override string ToString();

Return Value

A `string` that represents the same date and time as the current `OracleTimeStampLTZ` structure.

Remarks

The returned value is a string representation of the `OracleTimeStampLTZ` in the format specified by the `OracleGlobalization`.`TimeStampFormat` property of the thread.

The names and abbreviations used for months and days are in the language specified by the `DateLanguage` and `Calendar` properties of the thread's `OracleGlobalization` object. If any of the thread's globalization properties are set to null or an empty string, the client computer's settings are used.

Example

    // C#

    using System;
    using Oracle.DataAccess.Types;
    using Oracle.DataAccess.Client;

    class ToStringSample
    {
      static void Main()
      {
        // Set the nls_timestamp_format for the OracleTimeStampLTZ(string)
        // constructor
        OracleGlobalization info = OracleGlobalization.GetClientInfo();
        info.TimeStampFormat = "DD-MON-YYYY HH:MI:SS.FF AM";
        OracleGlobalization.SetThreadInfo(info);

        // construct OracleTimeStampLTZ from a string using the format
        // specified.
        OracleTimeStampLTZ ts =
          new OracleTimeStampLTZ("11-NOV-1999 11:02:33.444 AM");

        // Set the nls_timestamp_format for the ToString() method
        info.TimeStampFormat = "YYYY-MON-DD HH:MI:SS.FF AM";
        OracleGlobalization.SetThreadInfo(info);

        // Prints "1999-NOV-11 11:02:33.444000000 AM"
        Console.WriteLine(ts.ToString());
      }
    }

See Also: "Oracle.DataAccess.Types Namespace" OracleTimeStampLTZ Structure OracleTimeStampLTZ Members "OracleGlobalization Class" "Globalization Support"

### ToUniversalTime

This method converts the current local time to Coordinated Universal Time (UTC).

Declaration

    // C#
    public OracleTimeStampTZ ToUniversalTime();

Return Value

An `OracleTimeStampTZ` structure.

Remarks

If the current instance has a null value, the value of the returned `OracleTimeStampTZ` structure has a null value.

See Also: "Oracle.DataAccess.Types Namespace" OracleTimeStampLTZ Structure OracleTimeStampLTZ Members